DM Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	10296
Missing cells	372
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	172.8 B

Variable types

Numeric	11
Categorical	3

Alerts

`BirthYear` is highly correlated with `MonthSal`	High correlation
`MonthSal` is highly correlated with `BirthYear`	High correlation
`CustMonVal` is highly correlated with `ClaimsRate`	High correlation
`ClaimsRate` is highly correlated with `CustMonVal`	High correlation
`PremMotor` is highly correlated with `PremHousehold` and 3 other fields	High correlation
`PremHousehold` is highly correlated with `PremMotor`	High correlation
`PremHealth` is highly correlated with `PremMotor`	High correlation
`PremLife` is highly correlated with `PremMotor`	High correlation
`PremWork` is highly correlated with `PremMotor`	High correlation
`BirthYear` is highly correlated with `MonthSal`	High correlation
`MonthSal` is highly correlated with `BirthYear`	High correlation
`CustMonVal` is highly correlated with `ClaimsRate`	High correlation
`ClaimsRate` is highly correlated with `CustMonVal`	High correlation
`BirthYear` is highly correlated with `MonthSal`	High correlation
`MonthSal` is highly correlated with `BirthYear`	High correlation
`CustMonVal` is highly correlated with `ClaimsRate`	High correlation
`ClaimsRate` is highly correlated with `CustMonVal`	High correlation
`PremMotor` is highly correlated with `PremHealth` and 1 other fields	High correlation
`PremHealth` is highly correlated with `PremMotor`	High correlation
`PremLife` is highly correlated with `PremMotor`	High correlation
`CustMonVal` is highly correlated with `ClaimsRate`	High correlation
`ClaimsRate` is highly correlated with `CustMonVal`	High correlation
`PremHealth` is highly correlated with `PremWork`	High correlation
`PremWork` is highly correlated with `PremHealth`	High correlation
`PremLife` has 104 (1.0%) missing values	Missing
`FirstPolYear` is highly skewed (γ1 = 101.2958498)	Skewed
`CustMonVal` is highly skewed (γ1 = -67.04273979)	Skewed
`ClaimsRate` is highly skewed (γ1 = 71.20947447)	Skewed
`PremMotor` is highly skewed (γ1 = 23.87096035)	Skewed
`PremHousehold` is highly skewed (γ1 = 36.05402336)	Skewed
`PremHealth` is highly skewed (γ1 = 84.51949178)	Skewed
`CustID` is uniformly distributed	Uniform
`CustID` has unique values	Unique

Reproduction

Analysis started	2021-11-07 15:31:41.909125
Analysis finished	2021-11-07 15:32:06.241917
Duration	24.33 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

CustID
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	10296
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5148.5

Minimum	1
Maximum	10296
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.6 KiB

Quantile statistics

Minimum	1
5-th percentile	515.75
Q1	2574.75
median	5148.5
Q3	7722.25
95-th percentile	9781.25
Maximum	10296
Range	10295
Interquartile range (IQR)	5147.5

Descriptive statistics

Standard deviation	2972.34352
Coefficient of variation (CV)	0.5773222336
Kurtosis	-1.2
Mean	5148.5
Median Absolute Deviation (MAD)	2574
Skewness	0
Sum	53008956
Variance	8834826
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
6918	1	< 0.1%
6860	1	< 0.1%
6861	1	< 0.1%
6862	1	< 0.1%
6863	1	< 0.1%
6864	1	< 0.1%
6865	1	< 0.1%
6866	1	< 0.1%
6867	1	< 0.1%
Other values (10286)	10286	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
10296	1	< 0.1%
10295	1	< 0.1%
10294	1	< 0.1%
10293	1	< 0.1%
10292	1	< 0.1%
10291	1	< 0.1%
10290	1	< 0.1%
10289	1	< 0.1%
10288	1	< 0.1%
10287	1	< 0.1%

FirstPolYear
Real number (ℝ_≥0)

SKEWED

Distinct	26
Distinct (%)	0.3%
Missing	30
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1991.062634

Minimum	1974
Maximum	53784
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.6 KiB

Quantile statistics

Minimum	1974
5-th percentile	1976
Q1	1980
median	1986
Q3	1992
95-th percentile	1996
Maximum	53784
Range	51810
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	511.2679127
Coefficient of variation (CV)	0.2567814312
Kurtosis	10262.56551
Mean	1991.062634
Median Absolute Deviation (MAD)	6
Skewness	101.2958498
Sum	20440249
Variance	261394.8786
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
1988	512	5.0%
1994	475	4.6%
1993	473	4.6%
1989	466	4.5%
1984	464	4.5%
1986	458	4.4%
1977	453	4.4%
1978	453	4.4%
1992	451	4.4%
1990	449	4.4%
Other values (16)	5612	54.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1974	141	1.4%
1975	285	2.8%
1976	433	4.2%
1977	453	4.4%
1978	453	4.4%
1979	443	4.3%
1980	432	4.2%
1981	445	4.3%
1982	444	4.3%
1983	423	4.1%

Value	Count	Frequency (%)
53784	1	< 0.1%
1998	112	1.1%
1997	271	2.6%
1996	440	4.3%
1995	445	4.3%
1994	475	4.6%
1993	473	4.6%
1992	451	4.4%
1991	430	4.2%
1990	449	4.4%

BirthYear
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	68
Distinct (%)	0.7%
Missing	17
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1968.007783

Minimum	1028
Maximum	2001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.6 KiB

Quantile statistics

Minimum	1028
5-th percentile	1941
Q1	1953
median	1968
Q3	1983
95-th percentile	1995
Maximum	2001
Range	973
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	19.70947624
Coefficient of variation (CV)	0.01001493816
Kurtosis	501.8127652
Mean	1968.007783
Median Absolute Deviation (MAD)	15
Skewness	-10.53673466
Sum	20229152
Variance	388.4634537
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1962	206	2.0%
1968	200	1.9%
1964	194	1.9%
1953	193	1.9%
1981	190	1.8%
1990	189	1.8%
1974	187	1.8%
1951	186	1.8%
1952	186	1.8%
1963	186	1.8%
Other values (58)	8362	81.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1028	1	< 0.1%
1935	14	0.1%
1936	37	0.4%
1937	57	0.6%
1938	77	0.7%
1939	101	1.0%
1940	127	1.2%
1941	145	1.4%
1942	162	1.6%
1943	163	1.6%

Value	Count	Frequency (%)
2001	12	0.1%
2000	35	0.3%
1999	69	0.7%
1998	94	0.9%
1997	133	1.3%
1996	137	1.3%
1995	155	1.5%
1994	177	1.7%
1993	155	1.5%
1992	163	1.6%

EducDeg
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	692.2 KiB

3 - BSc/MSc	4799
2 - High School	3510
1 - Basic	1272
4 - PhD	698
	17

Length

Max length	15
Median length	11
Mean length	11.82721445
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2 - High School
2nd row	2 - High School
3rd row	1 - Basic
4th row	3 - BSc/MSc
5th row	3 - BSc/MSc

Common Values

Value	Count	Frequency (%)
3 - BSc/MSc	4799	46.6%
2 - High School	3510	34.1%
1 - Basic	1272	12.4%
4 - PhD	698	6.8%
	17	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
	10279	29.9%
3	4799	14.0%
bsc/msc	4799	14.0%
2	3510	10.2%
high	3510	10.2%
school	3510	10.2%
1	1272	3.7%
basic	1272	3.7%
4	698	2.0%
phd	698	2.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

MonthSal
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3565
Distinct (%)	34.7%
Missing	36
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	2506.667057

Minimum	333
Maximum	55215
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.6 KiB

Quantile statistics

Minimum	333
5-th percentile	933.9
Q1	1706
median	2501.5
Q3	3290.25
95-th percentile	4046
Maximum	55215
Range	54882
Interquartile range (IQR)	1584.25

Descriptive statistics

Standard deviation	1157.449634
Coefficient of variation (CV)	0.4617484524
Kurtosis	474.3813076
Mean	2506.667057
Median Absolute Deviation (MAD)	791.5
Skewness	11.25083378
Sum	25718404
Variance	1339689.656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3200	10	0.1%
1398	10	0.1%
3776	10	0.1%
2687	10	0.1%
3560	10	0.1%
2308	9	0.1%
1766	9	0.1%
3568	9	0.1%
2959	9	0.1%
2073	9	0.1%
Other values (3555)	10165	98.7%
(Missing)	36	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
333	3	< 0.1%
334	1	< 0.1%
335	3	< 0.1%
336	1	< 0.1%
340	1	< 0.1%
341	2	< 0.1%
342	1	< 0.1%
344	1	< 0.1%
346	1	< 0.1%
348	1	< 0.1%

Value	Count	Frequency (%)
55215	1	< 0.1%
34490	1	< 0.1%
5021	1	< 0.1%
4995	1	< 0.1%
4904	1	< 0.1%
4897	1	< 0.1%
4883	3	< 0.1%
4872	1	< 0.1%
4869	1	< 0.1%
4857	2	< 0.1%

GeoLivArea
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	603.4 KiB

4.0	4145
1.0	3048
3.0	2066
2.0	1036

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	4.0
3rd row	3.0
4th row	4.0
5th row	4.0

Common Values

Value	Count	Frequency (%)
4.0	4145	40.3%
1.0	3048	29.6%
3.0	2066	20.1%
2.0	1036	10.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
4.0	4145	40.3%
1.0	3048	29.6%
3.0	2066	20.1%
2.0	1036	10.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Children
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	21
Missing (%)	0.2%
Memory size	603.0 KiB

1.0	7262
0.0	3013

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	0.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	7262	70.5%
0.0	3013	29.3%
(Missing)	21	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	7262	70.7%
0.0	3013	29.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CustMonVal
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	7012
Distinct (%)	68.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	177.8926049

Minimum	-165680.42
Maximum	11875.89
Zeros	2
Zeros (%)	< 0.1%
Negative	2768
Negative (%)	26.9%
Memory size	80.6 KiB

Quantile statistics

Minimum	-165680.42
5-th percentile	-93.4875
Q1	-9.44
median	186.87
Q3	399.7775
95-th percentile	645.9325
Maximum	11875.89
Range	177556.31
Interquartile range (IQR)	409.2175

Descriptive statistics

Standard deviation	1945.811505
Coefficient of variation (CV)	10.93812475
Kurtosis	5323.18296
Mean	177.8926049
Median Absolute Deviation (MAD)	202.155
Skewness	-67.04273979
Sum	1831582.26
Variance	3786182.414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-25	272	2.6%
-31	12	0.1%
-37	11	0.1%
-35	11	0.1%
-15.11	10	0.1%
-12.33	10	0.1%
-47.67	10	0.1%
-33.89	9	0.1%
-10.33	9	0.1%
-21.11	9	0.1%
Other values (7002)	9933	96.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-165680.42	1	< 0.1%
-64891	1	< 0.1%
-52382.76	1	< 0.1%
-37327.08	1	< 0.1%
-28945.4	1	< 0.1%
-26130.45	1	< 0.1%
-14714.08	1	< 0.1%
-10198.91	1	< 0.1%
-10107.37	1	< 0.1%
-8719.04	1	< 0.1%

Value	Count	Frequency (%)
11875.89	1	< 0.1%
5596.84	1	< 0.1%
4328.5	1	< 0.1%
2314.21	1	< 0.1%
2054.07	1	< 0.1%
1997.6	1	< 0.1%
1891.04	1	< 0.1%
1801.45	1	< 0.1%
1716	1	< 0.1%
1691.43	1	< 0.1%

ClaimsRate
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	165
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7427719503

Minimum	0
Maximum	256.2
Zeros	58
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	80.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.16
Q1	0.39
median	0.72
Q3	0.98
95-th percentile	1.1
Maximum	256.2
Range	256.2
Interquartile range (IQR)	0.59

Descriptive statistics

Standard deviation	2.916963637
Coefficient of variation (CV)	3.927132192
Kurtosis	5877.806759
Mean	0.7427719503
Median Absolute Deviation (MAD)	0.28
Skewness	71.20947447
Sum	7647.58
Variance	8.508676861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	457	4.4%
1.01	212	2.1%
1.02	203	2.0%
0.99	198	1.9%
1.03	195	1.9%
0.98	173	1.7%
0.97	148	1.4%
0.95	143	1.4%
1.04	140	1.4%
0.91	139	1.4%
Other values (155)	8288	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	58	0.6%
0.01	2	< 0.1%
0.03	4	< 0.1%
0.04	5	< 0.1%
0.05	8	0.1%
0.06	20	0.2%
0.07	13	0.1%
0.08	37	0.4%
0.09	39	0.4%
0.1	28	0.3%

Value	Count	Frequency (%)
256.2	1	< 0.1%
96	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
35	1	< 0.1%
32.3	1	< 0.1%
25.36	1	< 0.1%
15.65	1	< 0.1%
14.8	1	< 0.1%
13.9	1	< 0.1%

PremMotor
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1950
Distinct (%)	19.0%
Missing	34
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	300.4702524

Minimum	-4.11
Maximum	11604.42
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	80.6 KiB

Quantile statistics

Minimum	-4.11
5-th percentile	63.68
Q1	190.59
median	298.61
Q3	408.3
95-th percentile	515.32
Maximum	11604.42
Range	11608.53
Interquartile range (IQR)	217.71

Descriptive statistics

Standard deviation	211.914997
Coefficient of variation (CV)	0.7052777947
Kurtosis	1096.286508
Mean	300.4702524
Median Absolute Deviation (MAD)	108.69
Skewness	23.87096035
Sum	3083425.73
Variance	44907.96595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
398.74	17	0.2%
361.29	16	0.2%
246.49	16	0.2%
206.15	15	0.1%
279.61	15	0.1%
409.52	14	0.1%
269.94	13	0.1%
346.51	13	0.1%
312.06	13	0.1%
210.26	13	0.1%
Other values (1940)	10117	98.3%
(Missing)	34	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4.11	1	< 0.1%
1.78	1	< 0.1%
3.78	2	< 0.1%
4.78	1	< 0.1%
6.78	1	< 0.1%
6.89	1	< 0.1%
7.67	1	< 0.1%
8.67	5	< 0.1%
9.67	1	< 0.1%
9.78	2	< 0.1%

Value	Count	Frequency (%)
11604.42	1	< 0.1%
8744.61	1	< 0.1%
5645.5	1	< 0.1%
4273.49	1	< 0.1%
4003.44	1	< 0.1%
3106.62	1	< 0.1%
585.22	1	< 0.1%
581.33	1	< 0.1%
580.11	1	< 0.1%
578.33	1	< 0.1%

PremHousehold
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct	1061
Distinct (%)	10.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	210.4311917

Minimum	-75
Maximum	25048.8
Zeros	60
Zeros (%)	0.6%
Negative	1097
Negative (%)	10.7%
Memory size	80.6 KiB

Quantile statistics

Minimum	-75
5-th percentile	-30
Q1	49.45
median	132.8
Q3	290.05
95-th percentile	695.7
Maximum	25048.8
Range	25123.8
Interquartile range (IQR)	240.6

Descriptive statistics

Standard deviation	352.595984
Coefficient of variation (CV)	1.675588021
Kurtosis	2427.155944
Mean	210.4311917
Median Absolute Deviation (MAD)	103.35
Skewness	36.05402336
Sum	2166599.55
Variance	124323.928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39.45	62	0.6%
0	60	0.6%
-45.55	60	0.6%
19.45	60	0.6%
-30.55	57	0.6%
-5.55	56	0.5%
69.45	55	0.5%
34.45	54	0.5%
44.45	54	0.5%
-40.55	53	0.5%
Other values (1051)	9725	94.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-75	18	0.2%
-70	34	0.3%
-65	35	0.3%
-60	31	0.3%
-55	27	0.3%
-50	44	0.4%
-45.55	60	0.6%
-45	37	0.4%
-40.55	53	0.5%
-40	33	0.3%

Value	Count	Frequency (%)
25048.8	1	< 0.1%
8762.8	1	< 0.1%
4130.7	1	< 0.1%
2223.75	1	< 0.1%
1957.6	1	< 0.1%
1924.25	1	< 0.1%
1918.15	1	< 0.1%
1826.45	1	< 0.1%
1777.55	2	< 0.1%
1748.1	1	< 0.1%

PremHealth
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1006
Distinct (%)	9.8%
Missing	43
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	171.5808329

Minimum	-2.11
Maximum	28272
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	< 0.1%
Memory size	80.6 KiB

Quantile statistics

Minimum	-2.11
5-th percentile	54.12
Q1	111.8
median	162.81
Q3	219.82
95-th percentile	297.39
Maximum	28272
Range	28274.11
Interquartile range (IQR)	108.02

Descriptive statistics

Standard deviation	296.4059761
Coefficient of variation (CV)	1.727500508
Kurtosis	7914.203507
Mean	171.5808329
Median Absolute Deviation (MAD)	54.01
Skewness	84.51949178
Sum	1759218.28
Variance	87856.50266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
130.47	30	0.3%
178.7	29	0.3%
159.14	28	0.3%
158.14	27	0.3%
147.36	26	0.3%
112.91	26	0.3%
169.7	26	0.3%
136.58	25	0.2%
151.03	25	0.2%
121.58	25	0.2%
Other values (996)	9986	97.0%
(Missing)	43	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2.11	1	< 0.1%
5.78	1	< 0.1%
7.78	1	< 0.1%
11.67	1	< 0.1%
12.67	1	< 0.1%
14.67	2	< 0.1%
15.56	1	< 0.1%
15.67	2	< 0.1%
16.56	4	< 0.1%
16.67	2	< 0.1%

Value	Count	Frequency (%)
28272	1	< 0.1%
7322.48	1	< 0.1%
1767	1	< 0.1%
1045.52	1	< 0.1%
442.86	1	< 0.1%
440.86	1	< 0.1%
432.97	1	< 0.1%
417.3	1	< 0.1%
417.08	1	< 0.1%
408.41	1	< 0.1%

PremLife
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	611
Distinct (%)	6.0%
Missing	104
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.85578199

Minimum	-7
Maximum	398.3
Zeros	0
Zeros (%)	0.0%
Negative	668
Negative (%)	6.5%
Memory size	80.6 KiB

Quantile statistics

Minimum	-7
5-th percentile	-1.11
Q1	9.89
median	25.56
Q3	57.79
95-th percentile	140.36
Maximum	398.3
Range	405.3
Interquartile range (IQR)	47.9

Descriptive statistics

Standard deviation	47.480632
Coefficient of variation (CV)	1.134386452
Kurtosis	5.716367231
Mean	41.85578199
Median Absolute Deviation (MAD)	19.56
Skewness	2.089846133
Sum	426594.13
Variance	2254.410416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.89	130	1.3%
3.89	121	1.2%
0.89	119	1.2%
-1.11	117	1.1%
12.89	109	1.1%
6.89	107	1.0%
5.89	106	1.0%
4.89	106	1.0%
7.89	102	1.0%
1.89	101	1.0%
Other values (601)	9074	88.1%
(Missing)	104	1.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-7	65	0.6%
-6	64	0.6%
-5	74	0.7%
-4	56	0.5%
-3	72	0.7%
-2	73	0.7%
-1.11	117	1.1%
-1	55	0.5%
-0.11	92	0.9%
0.89	119	1.2%

Value	Count	Frequency (%)
398.3	1	< 0.1%
365.18	1	< 0.1%
363.29	1	< 0.1%
354.4	1	< 0.1%
346.4	1	< 0.1%
341.51	1	< 0.1%
330.84	1	< 0.1%
329.73	1	< 0.1%
324.84	1	< 0.1%
320.06	1	< 0.1%

PremWork
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION

Distinct	898
Distinct (%)	8.8%
Missing	86
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	41.2775142

Minimum	-12
Maximum	1988.7
Zeros	0
Zeros (%)	0.0%
Negative	925
Negative (%)	9.0%
Memory size	80.6 KiB

Quantile statistics

Minimum	-12
5-th percentile	-4
Q1	10.67
median	25.67
Q3	56.79
95-th percentile	137.3105
Maximum	1988.7
Range	2000.7
Interquartile range (IQR)	46.12

Descriptive statistics

Standard deviation	51.51357235
Coefficient of variation (CV)	1.247981458
Kurtosis	212.7789142
Mean	41.2775142
Median Absolute Deviation (MAD)	19.45
Skewness	7.43811547
Sum	421443.42
Variance	2653.648136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.89	76	0.7%
9.89	72	0.7%
11.89	70	0.7%
-5.11	68	0.7%
-0.11	66	0.6%
1.89	65	0.6%
16.89	65	0.6%
3.89	64	0.6%
14.89	64	0.6%
4.89	63	0.6%
Other values (888)	9537	92.6%
(Missing)	86	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-12	34	0.3%
-11	32	0.3%
-10	32	0.3%
-9	29	0.3%
-8	51	0.5%
-7	39	0.4%
-6.11	57	0.6%
-6	44	0.4%
-5.11	68	0.7%
-5	48	0.5%

Value	Count	Frequency (%)
1988.7	1	< 0.1%
930.44	1	< 0.1%
494.1	1	< 0.1%
451.53	1	< 0.1%
417.08	1	< 0.1%
353.18	1	< 0.1%
352.62	1	< 0.1%
352.51	1	< 0.1%
350.62	1	< 0.1%
339.84	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	CustID	FirstPolYear	BirthYear	EducDeg	MonthSal	GeoLivArea	Children	CustMonVal	ClaimsRate	PremMotor	PremHousehold	PremHealth	PremLife	PremWork
0	1.0	1985.0	1982.0	2 - High School	2177.0	1.0	1.0	380.97	0.39	375.85	79.45	146.36	47.01	16.89
1	2.0	1981.0	1995.0	2 - High School	677.0	4.0	1.0	-131.13	1.12	77.46	416.20	116.69	194.48	106.13
2	3.0	1991.0	1970.0	1 - Basic	2277.0	3.0	0.0	504.67	0.28	206.15	224.50	124.58	86.35	99.02
3	4.0	1990.0	1981.0	3 - BSc/MSc	1099.0	4.0	1.0	-16.99	0.99	182.48	43.35	311.17	35.34	28.34
4	5.0	1986.0	1973.0	3 - BSc/MSc	1763.0	4.0	1.0	35.23	0.90	338.62	47.80	182.59	18.78	41.45
5	6.0	1986.0	1956.0	2 - High School	2566.0	4.0	1.0	-24.33	1.00	440.75	18.90	114.80	7.00	7.67
6	7.0	1979.0	1943.0	2 - High School	4103.0	4.0	0.0	-66.01	1.05	156.92	295.60	317.95	14.67	26.34
7	8.0	1988.0	1974.0	2 - High School	1743.0	4.0	1.0	-144.91	1.13	248.27	397.30	144.36	66.68	53.23
8	9.0	1981.0	1978.0	3 - BSc/MSc	1862.0	1.0	1.0	356.53	0.36	344.51	18.35	210.04	8.78	9.89
9	10.0	1976.0	1948.0	3 - BSc/MSc	3842.0	1.0	0.0	-119.35	1.12	209.26	182.25	271.94	39.23	55.12

Last rows

	CustID	FirstPolYear	BirthYear	EducDeg	MonthSal	GeoLivArea	Children	CustMonVal	ClaimsRate	PremMotor	PremHousehold	PremHealth	PremLife	PremWork
10286	10287.0	1997.0	1943.0	3 - BSc/MSc	3975.0	2.0	0.0	220.27	0.62	285.61	77.25	241.49	31.45	8.89
10287	10288.0	1996.0	1941.0	2 - High School	3845.0	4.0	0.0	99.47	0.90	87.35	843.50	121.58	157.92	33.45
10288	10289.0	1982.0	1993.0	2 - High School	1465.0	1.0	1.0	795.15	0.35	67.79	820.15	102.13	182.48	86.46
10289	10290.0	1986.0	1943.0	2 - High School	3498.0	4.0	0.0	245.60	0.67	227.82	270.60	160.92	100.13	69.90
10290	10291.0	1994.0	1999.0	1 - Basic	626.0	3.0	1.0	176.26	0.85	6.89	878.50	103.13	113.02	201.26
10291	10292.0	1984.0	1949.0	4 - PhD	3188.0	2.0	0.0	-0.11	0.96	393.74	49.45	173.81	9.78	14.78
10292	10293.0	1977.0	1952.0	1 - Basic	2431.0	3.0	0.0	1405.60	0.00	133.58	1035.75	143.25	12.89	105.13
10293	10294.0	1994.0	1976.0	3 - BSc/MSc	2918.0	1.0	1.0	524.10	0.21	403.63	132.80	142.25	12.67	4.89
10294	10295.0	1981.0	1977.0	1 - Basic	1971.0	2.0	1.0	250.05	0.65	188.59	211.15	198.37	63.90	112.91
10295	10296.0	1990.0	1981.0	4 - PhD	2815.0	1.0	1.0	463.75	0.27	414.08	94.45	141.25	6.89	12.89

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows